
/* 

Paper: Gentrification and pioneer businesses 
Authors: Behrens, Boulam, Martin, Mayneris 

Name dofile: table3.do  
Version: 10 nov. 2021 

Output: table 6 on the list of non-pioneer creative sectors, and sectors with similar worker characteristics  

Inputs:

 - list_oth_crea_similar [built by the authors] [publicly available]

*/ 

use list_oth_crea_similar, clear
drop if naics==454110 // dropped throughout the paper (online shopping -- because NETS data for this sector are noisy)
tostring naics, replace
keep naics similar creative 
merge 1:1 naics using pioneers_final_negbin.dta // merge to get naics label
keep if pioneer_high_negbin==0
keep if (similar==1 | creative==1) 
g type="similar"
replace type="creative" if creative==1
keep naics naicsdescription type 
sort type naics

export excel using table6.xls, replace
